<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * SQL Parser Matching Data
 *
 * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
 * http://www.orbis-terrarum.net/?l=people.robbat2
 *
 * This data is used by the SQL Parser to recognize keywords
 *
 * It has been extracted from the lex.h file in the MySQL BK tree
 * (around 4.0.2) as well as the MySQL documentation.
 *
 * Note: before adding a value in the arrays, ensure that you respect
 * proper sorting, especially with underscores. And don't forget to
 * update the _cnt variable at the end of each array.
 * (It's slower to have PHP do the count).
 *
 * It's easier to use only uppercase for proper sorting. In case of
 * doubt, use the DEBUG code after this function's definition.
 *
 * @version$Id: sqlparser.data.php 11345 2008-06-24 17:51:49Z lem9 $
 */
if (! defined('PHPMYADMIN')) {
	exit;
}

/**
 * @global array MySQL function names
 */
$PMA_SQPdata_function_name = array (
	'ABS',
	'ACOS',
	'ADDDATE',
	'ADDTIME',
	'AES_DECRYPT',
	'AES_ENCRYPT',
	'AREA',					 // Area() polygon-property-functions.html
	'ASBINARY',				 // AsBinary()
	'ASCII',
	'ASIN',
	'ASTEXT',				   // AsText()
	'ATAN',
	'ATAN2',
	'AVG',
	'BDMPOLYFROMTEXT',		  // BdMPolyFromText()
	'BDMPOLYFROMWKB',		   // BdMPolyFromWKB()
	'BDPOLYFROMTEXT',		   // BdPolyFromText()
	'BDPOLYFROMWKB',			// BdPolyFromWKB()
	'BENCHMARK',
	'BIN',
	'BIT_AND',
	'BIT_COUNT',
	'BIT_LENGTH',
	'BIT_OR',
	'BIT_XOR',				  // group-by-functions.html
	'BOUNDARY',				 // Boundary() general-geometry-property-functions.html
	'BUFFER',				   // Buffer()
	'CAST',
	'CEIL',
	'CEILING',
	'CENTROID',				 // Centroid() multipolygon-property-functions.html
	'CHAR',					 // string-functions.html
	'CHARACTER_LENGTH',
	'CHARSET',				  // information-functions.html
	'CHAR_LENGTH',
	'COALESCE',
	'COERCIBILITY',			 // information-functions.html
	'COLLATION',				// information-functions.html
	'COMPRESS',				 // string-functions.html
	'CONCAT',
	'CONCAT_WS',
	'CONNECTION_ID',
	'CONTAINS',				 // Contains()
	'CONV',
	'CONVERT',
	'CONVERT_TZ',
	'CONVEXHULL',			   // ConvexHull()
	'COS',
	'COT',
	'COUNT',
	'CRC32',					// mathematical-functions.html
	'CROSSES',				  // Crosses()
	'CURDATE',
	'CURRENT_DATE',
	'CURRENT_TIME',
	'CURRENT_TIMESTAMP',
	'CURRENT_USER',
	'CURTIME',
	'DATABASE',
	'DATE',					 // date-and-time-functions.html
	'DATEDIFF',				 // date-and-time-functions.html
	'DATE_ADD',
	'DATE_DIFF',
	'DATE_FORMAT',
	'DATE_SUB',
	'DAY',
	'DAYNAME',
	'DAYOFMONTH',
	'DAYOFWEEK',
	'DAYOFYEAR',
	'DECODE',
	'DEFAULT',				  // miscellaneous-functions.html
	'DEGREES',
	'DES_DECRYPT',
	'DES_ENCRYPT',
	'DIFFERENCE',			   // Difference()
	'DIMENSION',				// Dimension() general-geometry-property-functions.html
	'DISJOINT',				 // Disjoint()
	'DISTANCE',				 // Distance()
	'ELT',
	'ENCODE',
	'ENCRYPT',
	'ENDPOINT',				 // EndPoint() linestring-property-functions.html
	'ENVELOPE',				 // Envelope() general-geometry-property-functions.html
	'EQUALS',				   // Equals()
	'EXP',
	'EXPORT_SET',
	'EXTERIORRING',			 // ExteriorRing() polygon-property-functions.html
	'EXTRACT',
	'EXTRACTVALUE',			 // ExtractValue() xml-functions.html
	'FIELD',
	'FIND_IN_SET',
	'FLOOR',
	'FORMAT',
	'FOUND_ROWS',
	'FROM_DAYS',
	'FROM_UNIXTIME',
	'GEOMCOLLFROMTEXT',		 // GeomCollFromText()
	'GEOMCOLLFROMWKB',		  // GeomCollFromWKB()
	'GEOMETRYCOLLECTION',	   // GeometryCollection()
	'GEOMETRYCOLLECTIONFROMTEXT',   // GeometryCollectionFromText()
	'GEOMETRYCOLLECTIONFROMWKB',	// GeometryCollectionFromWKB()
	'GEOMETRYFROMTEXT',		 // GeometryFromText()
	'GEOMETRYFROMWKB',		  // GeometryFromWKB()
	'GEOMETRYN',				// GeometryN() geometrycollection-property-functions.html
	'GEOMETRYTYPE',			 // GeometryType() general-geometry-property-functions.html
	'GEOMFROMTEXT',			 // GeomFromText()
	'GEOMFROMWKB',			  // GeomFromWKB()
	'GET_FORMAT',
	'GET_LOCK',
	'GLENGTH',				  // GLength() linestring-property-functions.html
	'GREATEST',
	'GROUP_CONCAT',
	'GROUP_UNIQUE_USERS',
	'HEX',
	'HOUR',
	'IF',					   //control-flow-functions.html
	'IFNULL',
	'INET_ATON',
	'INET_NTOA',
	'INSERT',				   // string-functions.html
	'INSTR',
	'INTERIORRINGN',			// InteriorRingN() polygon-property-functions.html
	'INTERSECTION',			 // Intersection()
	'INTERSECTS',			   // Intersects()
	'INTERVAL',
	'ISCLOSED',				 // IsClosed() multilinestring-property-functions.html
	'ISEMPTY',				  // IsEmpty() general-geometry-property-functions.html
	'ISNULL',
	'ISRING',				   // IsRing() linestring-property-functions.html
	'ISSIMPLE',				 // IsSimple() general-geometry-property-functions.html
	'IS_FREE_LOCK',
	'IS_USED_LOCK',			 // miscellaneous-functions.html
	'LAST_DAY',
	'LAST_INSERT_ID',
	'LCASE',
	'LEAST',
	'LEFT',
	'LENGTH',
	'LINEFROMTEXT',			 // LineFromText()
	'LINEFROMWKB',			  // LineFromWKB()
	'LINESTRING',			   // LineString()
	'LINESTRINGFROMTEXT',	   // LineStringFromText()
	'LINESTRINGFROMWKB',		// LineStringFromWKB()
	'LN',
	'LOAD_FILE',
	'LOCALTIME',
	'LOCALTIMESTAMP',
	'LOCATE',
	'LOG',
	'LOG10',
	'LOG2',
	'LOWER',
	'LPAD',
	'LTRIM',
	'MAKEDATE',
	'MAKETIME',
	'MAKE_SET',
	'MASTER_POS_WAIT',
	'MAX',
	'MBRCONTAINS',			  // MBRContains()
	'MBRDISJOINT',			  // MBRDisjoint()
	'MBREQUAL',				 // MBREqual()
	'MBRINTERSECTS',			// MBRIntersects()
	'MBROVERLAPS',			  // MBROverlaps()
	'MBRTOUCHES',			   // MBRTouches()
	'MBRWITHIN',				// MBRWithin()
	'MD5',
	'MICROSECOND',
	'MID',
	'MIN',
	'MINUTE',
	'MLINEFROMTEXT',			// MLineFromText()
	'MLINEFROMWKB',			 // MLineFromWKB()
	'MOD',
	'MONTH',
	'MONTHNAME',
	'NOW',
	'MPOINTFROMTEXT',		   // MPointFromText()
	'MPOINTFROMWKB',			// MPointFromWKB()
	'MPOLYFROMTEXT',			// MPolyFromText()
	'MPOLYFROMWKB',			 // MPolyFromWKB()
	'MULTILINESTRING',		  // MultiLineString()
	'MULTILINESTRINGFROMTEXT',  // MultiLineStringFromText()
	'MULTILINESTRINGFROMWKB',   // MultiLineStringFromWKB()
	'MULTIPOINT',			   // MultiPoint()
	'MULTIPOINTFROMTEXT',	   // MultiPointFromText()
	'MULTIPOINTFROMWKB',		// MultiPointFromWKB()
	'MULTIPOLYGON',			 // MultiPolygon()
	'MULTIPOLYGONFROMTEXT',	 // MultiPolygonFromText()
	'MULTIPOLYGONFROMWKB',	  // MultiPolygonFromWKB()
	'NAME_CONST',			   // NAME_CONST()
	'NOW',					  // NOW()
	'NULLIF',
	'NUMGEOMETRIES',			// NumGeometries() geometrycollection-property-functions.html
	'NUMINTERIORRINGS',		 // NumInteriorRings() polygon-property-functions.html
	'NUMPOINTS',				// NumPoints() linestring-property-functions.html
	'OCT',
	'OCTET_LENGTH',
	'OLD_PASSWORD',
	'ORD',
	'OVERLAPS',				 // Overlaps()
	'PASSWORD',
	'PERIOD_ADD',
	'PERIOD_DIFF',
	'PI',
	'POINT',					// Point()
	'POINTFROMTEXT',			// PointFromText()
	'POINTFROMWKB',			 // PointFromWKB()
	'POINTN',				   // PointN() inestring-property-functions.html
	'POINTONSURFACE',		   // PointOnSurface() multipolygon-property-functions.html
	'POLYFROMTEXT',			 // PolyFromText()
	'POLYFROMWKB',			  // PolyFromWKB()
	'POLYGON',				  // Polygon()
	'POLYGONFROMTEXT',		  // PolygonFromText()
	'POLYGONFROMWKB',		   // PolygonFromWKB()
	'POSITION',
	'POW',
	'POWER',
	'QUARTER',
	'QUOTE',
	'RADIANS',
	'RAND',
	'RELATED',				  // Related()
	'RELEASE_LOCK',
	'REPEAT',
	'REPLACE',				  // string-functions.html
	'REVERSE',
	'RIGHT',
	'ROUND',
	'ROW_COUNT',				// information-functions.html
	'RPAD',
	'RTRIM',
	'SCHEMA',				   // information-functions.html
	'SECOND',
	'SEC_TO_TIME',
	'SESSION_USER',
	'SHA',
	'SHA1',
	'SIGN',
	'SIN',
	'SLEEP',					// miscellaneous-functions.html
	'SOUNDEX',
	'SPACE',
	'SQRT',
	'SRID',					 // general-geometry-property-functions.html
	'STARTPOINT',			   // StartPoint() linestring-property-functions.html
	'STD',
	'STDDEV',
	'STDDEV_POP',			   // group-by-functions.html
	'STDDEV_SAMP',			  // group-by-functions.html
	'STRCMP',
	'STR_TO_DATE',
	'SUBDATE',
	'SUBSTR',
	'SUBSTRING',
	'SUBSTRING_INDEX',
	'SUBTIME',
	'SUM',
	'SYMDIFFERENCE',			// SymDifference()
	'SYSDATE',
	'SYSTEM_USER',
	'TAN',
	'TIME',
	'TIMEDIFF',
	'TIMESTAMP',
	'TIMESTAMPADD',
	'TIMESTAMPDIFF',
	'TIME_FORMAT',
	'TIME_TO_SEC',
	'TOUCHES',				  // Touches()
	'TO_DAYS',
	'TRIM',
	'TRUNCATE',				 // mathematical-functions.html
	'UCASE',
	'UNCOMPRESS',			   // string-functions.html
	'UNCOMPRESSED_LENGTH',	  // string-functions.html
	'UNHEX',					// string-functions.html
	'UNIQUE_USERS',
	'UNIX_TIMESTAMP',
	'UPDATEXML',				// UpdateXML() xml-functions.html
	'UPPER',
	'USER',
	'UTC_DATE',
	'UTC_TIME',
	'UTC_TIMESTAMP',
	'UUID',					 // miscellaneous-functions.html
	'VARIANCE',				 // group-by-functions.html
	'VAR_POP',				  // group-by-functions.html
	'VAR_SAMP',				 // group-by-functions.html
	'VERSION',
	'WEEK',
	'WEEKDAY',
	'WEEKOFYEAR',
	'WITHIN',				   // Within()
	'X',						// point-property-functions.html
	'Y',						// point-property-functions.html
	'YEAR',
	'YEARWEEK'
);
/**
 * $PMA_SQPdata_function_name_cnt = count($PMA_SQPdata_function_name);
 *
 * @global integer MySQL attributes count
 */
$PMA_SQPdata_function_name_cnt = 299;

/*
 * DEBUG
$test_PMA_SQPdata_function_name = $PMA_SQPdata_function_name;
sort($PMA_SQPdata_function_name);
if ($PMA_SQPdata_function_name != $test_PMA_SQPdata_function_name) {
	echo 'sort properly like this<pre>';
	print_r($PMA_SQPdata_function_name);
	echo '</pre>';
}
 */

/**
 * @global array MySQL attributes
 */
$PMA_SQPdata_column_attrib = array (
	'ARCHIVE',		  // Engine
	'ASCII',
	'AUTO_INCREMENT',
	'BDB',			  // Engine
	'BERKELEYDB',	   // Engine alias BDB
	'BINARY',
	'BLACKHOLE',		// Engine
	'CSV',			  // Engine
	'DEFAULT',
	'EXAMPLE',		  // Engine
	'FEDERATED',		// Engine
	'HEAP',			 // Engine
	'INNOBASE',		 // Engine alias InnoDB
	'INNODB',		   // Engine InnoDB
	'ISAM',			 // Engine
	'MEMORY',		   // Engine alias HEAP, but preferred
	'MERGE',			// Engine
	'MRG_ISAM',		 // Engine
	'MRG_MYISAM',	   // Engine alias MERGE
	'MYISAM',		   // Engine MyISAM
	'NATIONAL',
	'NDB',			  // Engine alias NDBCLUSTER
	'NDBCLUSTER',	   // Engine
	'PRECISION',
	'UNDEFINED',
	'UNICODE',
	'UNSIGNED',
	'VARYING',
	'ZEROFILL'
);
/**
 * $PMA_SQPdata_column_attrib_cnt = count($PMA_SQPdata_column_attrib);
 *
 * @global integer MySQL attributes count
 */
$PMA_SQPdata_column_attrib_cnt = 29;

/**
 * words that are reserved by MySQL and may not be used as identifiers without quotes
 *
 * @see http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html
 *
 * @global array MySQL reserved words
 */
$PMA_SQPdata_reserved_word = array (
	'ACCESSIBLE',	   // 5.1
	'ACTION',
	'ADD',
	'AFTER',
	'AGAINST',
	'AGGREGATE',
	'ALGORITHM',
	'ALL',
	'ALTER',
	'ANALYSE',
	'ANALYZE',
	'AND',
	'AS',
	'ASC',
	'AUTOCOMMIT',
	'AUTO_INCREMENT',
	'AVG_ROW_LENGTH',
	'BACKUP',
	'BEGIN',
	'BETWEEN',
	'BINLOG',
	'BOTH',
	'BY',
	'CASCADE',
	'CASE',
	'CHANGE',
	'CHANGED',
	'CHARSET',
	'CHECK',
	'CHECKSUM',
	'COLLATE',
	'COLLATION',
	'COLUMN',
	'COLUMNS',
	'COMMENT',
	'COMMIT',
	'COMMITTED',
	'COMPRESSED',
	'CONCURRENT',
	'CONSTRAINT',
	'CONTAINS',
	'CONVERT',
	'CREATE',
	'CROSS',
	'CURRENT_TIMESTAMP',
	'DATA',
	'DATABASE',
	'DATABASES',
	'DAY',
	'DAY_HOUR',
	'DAY_MINUTE',
	'DAY_SECOND',
	'DEFINER',
	'DELAYED',
	'DELAY_KEY_WRITE',
	'DELETE',
	'DESC',
	'DESCRIBE',
	'DETERMINISTIC',
	'DISTINCT',
	'DISTINCTROW',
	'DIV',
	'DO',
	'DROP',
	'DUMPFILE',
	'DUPLICATE',
	'DYNAMIC',
	'ELSE',
	'ENCLOSED',
	'END',
	'ENGINE',
	'ENGINES',
	'ESCAPE',
	'ESCAPED',
	'EVENTS',
	'EXECUTE',
	'EXISTS',
	'EXPLAIN',
	'EXTENDED',
	'FAST',
	'FIELDS',
	'FILE',
	'FIRST',
	'FIXED',
	'FLUSH',
	'FOR',
	'FORCE',
	'FOREIGN',
	'FROM',
	'FULL',
	'FULLTEXT',
	'FUNCTION',
	'GEMINI',
	'GEMINI_SPIN_RETRIES',
	'GLOBAL',
	'GRANT',
	'GRANTS',
	'GROUP',
	'HAVING',
	'HEAP',
	'HIGH_PRIORITY',
	'HOSTS',
	'HOUR',
	'HOUR_MINUTE',
	'HOUR_SECOND',
	'IDENTIFIED',
	'IF',
	'IGNORE',
	'IN',
	'INDEX',
	'INDEXES',
	'INFILE',
	'INNER',
	'INSERT',
	'INSERT_ID',
	'INSERT_METHOD',
	'INTERVAL',
	'INTO',
	'IS',
	'ISOLATION',
	'JOIN',
	'KEY',
	'KEYS',
	'KILL',
	'LAST_INSERT_ID',
	'LEADING',
	'LEFT',
	'LEVEL',
	'LIKE',
	'LIMIT',
	'LINEAR',			   // 5.1
	'LINES',
	'LOAD',
	'LOCAL',
	'LOCK',
	'LOCKS',
	'LOGS',
	'LOW_PRIORITY',
	'MASTER',
	'MASTER_CONNECT_RETRY',
	'MASTER_HOST',
	'MASTER_LOG_FILE',
	'MASTER_LOG_POS',
	'MASTER_PASSWORD',
	'MASTER_PORT',
	'MASTER_USER',
	'MATCH',
	'MAX_CONNECTIONS_PER_HOUR',
	'MAX_QUERIES_PER_HOUR',
	'MAX_ROWS',
	'MAX_UPDATES_PER_HOUR',
	'MAX_USER_CONNECTIONS',
	'MEDIUM',
	'MERGE',
	'MINUTE',
	'MINUTE_SECOND',
	'MIN_ROWS',
	'MODE',
	'MODIFY',
	'MONTH',
	'MRG_MYISAM',
	'MYISAM',
	'NAMES',
	'NATURAL',
	// 'NO' is not allowed in SQL-99 but is allowed in MySQL
	//'NO',
	'NOT',
	'NULL',
	'OFFSET',
	'ON',
	'OPEN',
	'OPTIMIZE',
	'OPTION',
	'OPTIONALLY',
	'OR',
	'ORDER',
	'OUTER',
	'OUTFILE',
	'PACK_KEYS',
	'PARTIAL',
	'PASSWORD',
	'PRIMARY',
	'PRIVILEGES',
	'PROCEDURE',
	'PROCESS',
	'PROCESSLIST',
	'PURGE',
	'QUICK',
	'RAID0',
	'RAID_CHUNKS',
	'RAID_CHUNKSIZE',
	'RAID_TYPE',
	'RANGE',				// 5.1
	'READ',
	'READ_ONLY',			// 5.1
	'READ_WRITE',		   // 5.1
	'REFERENCES',
	'REGEXP',
	'RELOAD',
	'RENAME',
	'REPAIR',
	'REPEATABLE',
	'REPLACE',
	'REPLICATION',
	'RESET',
	'RESTORE',
	'RESTRICT',
	'RETURN',
	'RETURNS',
	'REVOKE',
	'RIGHT',
	'RLIKE',
	'ROLLBACK',
	'ROW',
	'ROWS',
	'ROW_FORMAT',
	'SECOND',
	'SECURITY',
	'SELECT',
	'SEPARATOR',
	'SERIALIZABLE',
	'SESSION',
	'SHARE',
	'SHOW',
	'SHUTDOWN',
	'SLAVE',
	'SONAME',
	'SOUNDS',				   // string-functions.html
	'SQL',
	'SQL_AUTO_IS_NULL',
	'SQL_BIG_RESULT',
	'SQL_BIG_SELECTS',
	'SQL_BIG_TABLES',
	'SQL_BUFFER_RESULT',
	'SQL_CACHE',
	'SQL_CALC_FOUND_ROWS',
	'SQL_LOG_BIN',
	'SQL_LOG_OFF',
	'SQL_LOG_UPDATE',
	'SQL_LOW_PRIORITY_UPDATES',
	'SQL_MAX_JOIN_SIZE',
	'SQL_NO_CACHE',
	'SQL_QUOTE_SHOW_CREATE',
	'SQL_SAFE_UPDATES',
	'SQL_SELECT_LIMIT',
	'SQL_SLAVE_SKIP_COUNTER',
	'SQL_SMALL_RESULT',
	'SQL_WARNINGS',
	'START',
	'STARTING',
	'STATUS',
	'STOP',
	'STORAGE',
	'STRAIGHT_JOIN',
	'STRING',
	'STRIPED',
	'SUPER',
	'TABLE',
	'TABLES',
	'TEMPORARY',
	'TERMINATED',
	'THEN',
	'TO',
	'TRAILING',
	'TRUNCATE',
	'TYPE',
	'TYPES',
	'UNCOMMITTED',
	'UNION',
	'UNIQUE',
	'UNLOCK',
	'UPDATE',
	'USAGE',
	'USE',
	'USING',
	'VALUES',
	'VARIABLES',
	'VIEW',
	'WHEN',
	'WHERE',
	'WITH',
	'WORK',
	'WRITE',
	'XOR',
	'YEAR_MONTH'
);
/**
 * $PMA_SQPdata_reserved_word_cnt = count($PMA_SQPdata_reserved_word);
 *
 * @global integer MySQL reserved words count
 */
$PMA_SQPdata_reserved_word_cnt = 283;
/**
 * The previous array must be sorted so that the binary search work. 
 * Sometimes a word is not added in the correct order, so
 * this debugging code shows the problem. The same should be
 * done for all arrays.
 */
/*
$original = $PMA_SQPdata_reserved_word;
sort($PMA_SQPdata_reserved_word);
$difference = array_diff_assoc($original, $PMA_SQPdata_reserved_word);
echo '<pre>';
print_r($difference);
echo '</pre>';
echo '<pre>';
print_r($PMA_SQPdata_reserved_word);
echo '</pre>';
*/
/**
 * words forbidden to be used as column or table name wihtout quotes
 * as seen in http://dev.mysql.com/doc/mysql/en/reserved-words.html
 *
 * @global array MySQL forbidden words
 */
$PMA_SQPdata_forbidden_word = array (
	'ACCESSIBLE',	   // 5.1
	'ACTION',
	'ADD',
	'AFTER',
	'AGAINST',
	'AGGREGATE',
	'ALGORITHM',
	'ALL',
	'ALTER',
	'ANALYZE',
	'AND',
	'ANY',
	'AS',
	'ASC',
	'ASCII',
	'ASENSITIVE',
	'AUTO_INCREMENT',
	'AVG',
	'AVG_ROW_LENGTH',
	'BACKUP',
	'BDB',
	'BEFORE',
	'BEGIN',
	'BERKELEYDB',
	'BETWEEN',
	'BIGINT',
	'BINARY',
	'BINLOG',
	'BIT',
	'BLOB',
	'BOOL',
	'BOOLEAN',
	'BOTH',
	'BTREE',
	'BY',
	'BYTE',
	'CACHE',
	'CALL',
	'CASCADE',
	'CASCADED',
	'CASE',
	'CHAIN',
	'CHANGE',
	'CHANGED',
	'CHAR',
	'CHARACTER',
	'CHARSET',
	'CHECK',
	'CHECKSUM',
	'CIPHER',
	'CLOSE',
	'COLLATE',
	'COLLATION',
	'COLUMN',
	'COLUMNS',
	'COMMENT',
	'COMMIT',
	'COMMITTED',
	'COMPACT',
	'COMPRESSED',
	'CONCURRENT',
	'CONDITION',
	'CONNECTION',
	'CONSISTENT',
	'CONSTRAINT',
	'CONTAINS',
	'CONTINUE',
	'CONVERT',
	'CREATE',
	'CROSS',
	'CUBE',
	'CURRENT_DATE',
	'CURRENT_TIME',
	'CURRENT_TIMESTAMP',
	'CURRENT_USER',
	'CURSOR',
	'DATA',
	'DATABASE',
	'DATABASES',
	'DATE',
	'DATETIME',
	'DAY',
	'DAY_HOUR',
	'DAY_MICROSECOND',
	'DAY_MINUTE',
	'DAY_SECOND',
	'DEALLOCATE',
	'DEC',
	'DECIMAL',
	'DECLARE',
	'DEFAULT',
	'DEFINER',
	'DELAYED',
	'DELAY_KEY_WRITE',
	'DELETE',
	'DESC',
	'DESCRIBE',
	'DES_KEY_FILE',
	'DETERMINISTIC',
	'DIRECTORY',
	'DISABLE',
	'DISCARD',
	'DISTINCT',
	'DISTINCTROW',
	'DIV',
	'DO',
	'DOUBLE',
	'DROP',
	'DUAL',
	'DUMPFILE',
	'DUPLICATE',
	'DYNAMIC',
	'EACH',
	'ELSE',
	'ELSEIF',
	'ENABLE',
	'ENCLOSED',
	'END',
	'ENGINE',
	'ENGINES',
	'ENUM',
	'ERRORS',
	'ESCAPE',
	'ESCAPED',
	'EVENTS',
	'EXECUTE',
	'EXISTS',
	'EXIT',
	'EXPANSION',
	'EXPLAIN',
	'EXTENDED',
	'FALSE',
	'FAST',
	'FETCH',
	'FIELDS',
	'FILE',
	'FIRST',
	'FIXED',
	'FLOAT',
	'FLOAT4',
	'FLOAT8',
	'FLUSH',
	'FOR',
	'FORCE',
	'FOREIGN',
	'FOUND',
	'FRAC_SECOND',
	'FROM',
	'FULL',
	'FULLTEXT',
	'FUNCTION',
	'GEOMETRY',
	'GEOMETRYCOLLECTION',
	'GET_FORMAT',
	'GLOBAL',
	'GOTO',
	'GRANT',
	'GRANTS',
	'GROUP',
	'HANDLER',
	'HASH',
	'HAVING',
	'HELP',
	'HIGH_PRIORITY',
	'HOSTS',
	'HOUR',
	'HOUR_MICROSECOND',
	'HOUR_MINUTE',
	'HOUR_SECOND',
	'IDENTIFIED',
	'IF',
	'IGNORE',
	'IMPORT',
	'IN',
	'INDEX',
	'INDEXES',
	'INFILE',
	'INNER',
	'INNOBASE',
	'INNODB',
	'INOUT',
	'INSENSITIVE',
	'INSERT',
	'INSERT_METHOD',
	'INT',
	'INT1',
	'INT2',
	'INT3',
	'INT4',
	'INT8',
	'INTEGER',
	'INTERVAL',
	'INTO',
	'INVOKER',
	'IO_THREAD',
	'IS',
	'ISOLATION',
	'ISSUER',
	'ITERATE',
	'JOIN',
	'KEY',
	'KEYS',
	'KILL',
	'LABEL',
	'LANGUAGE',
	'LAST',
	'LEADING',
	'LEAVE',
	'LEAVES',
	'LEFT',
	'LEVEL',
	'LIKE',
	'LIMIT',
	'LINEAR',			   // 5.1
	'LINES',
	'LINESTRING',
	'LOAD',
	'LOCAL',
	'LOCALTIME',
	'LOCALTIMESTAMP',
	'LOCK',
	'LOCKS',
	'LOGS',
	'LONG',
	'LONGBLOB',
	'LONGTEXT',
	'LOOP',
	'LOW_PRIORITY',
	'MASTER',
	'MASTER_CONNECT_RETRY',
	'MASTER_HOST',
	'MASTER_LOG_FILE',
	'MASTER_LOG_POS',
	'MASTER_PASSWORD',
	'MASTER_PORT',
	'MASTER_SERVER_ID',
	'MASTER_SSL',
	'MASTER_SSL_CA',
	'MASTER_SSL_CAPATH',
	'MASTER_SSL_CERT',
	'MASTER_SSL_CIPHER',
	'MASTER_SSL_KEY',
	'MASTER_USER',
	'MATCH',
	'MAX_CONNECTIONS_PER_HOUR',
	'MAX_QUERIES_PER_HOUR',
	'MAX_ROWS',
	'MAX_UPDATES_PER_HOUR',
	'MAX_USER_CONNECTIONS',
	'MEDIUM',
	'MEDIUMBLOB',
	'MEDIUMINT',
	'MEDIUMTEXT',
	'MERGE',
	'MICROSECOND',
	'MIDDLEINT',
	'MIGRATE',
	'MINUTE',
	'MINUTE_MICROSECOND',
	'MINUTE_SECOND',
	'MIN_ROWS',
	'MOD',
	'MODE',
	'MODIFIES',
	'MODIFY',
	'MONTH',
	'MULTILINESTRING',
	'MULTIPOINT',
	'MULTIPOLYGON',
	'MUTEX',
	'NAME',
	'NAMES',
	'NATIONAL',
	'NATURAL',
	'NCHAR',
	'NDB',
	'NDBCLUSTER',
	'NEW',
	'NEXT',
	'NO',
	'NONE',
	'NOT',
	'NO_WRITE_TO_BINLOG',
	'NULL',
	'NUMERIC',
	'NVARCHAR',
	'OFFSET',
	'OLD_PASSWORD',
	'ON',
	'ONE',
	'ONE_SHOT',
	'OPEN',
	'OPTIMIZE',
	'OPTION',
	'OPTIONALLY',
	'OR',
	'ORDER',
	'OUT',
	'OUTER',
	'OUTFILE',
	'PACK_KEYS',
	'PARTIAL',
	'PASSWORD',
	'PHASE',
	'POINT',
	'POLYGON',
	'PRECISION',
	'PREPARE',
	'PREV',
	'PRIMARY',
	'PRIVILEGES',
	'PROCEDURE',
	'PROCESSLIST',
	'PURGE',
	'QUARTER',
	'QUERY',
	'QUICK',
	'RAID0',
	'RAID_CHUNKS',
	'RAID_CHUNKSIZE',
	'RAID_TYPE',
	'RANGE',				// 5.1
	'READ',
	'READ_ONLY',			// 5.1
	'READ_WRITE',		   // 5.1
	'READS',
	'REAL',
	'RECOVER',
	'REDUNDANT',
	'REFERENCES',
	'REGEXP',
	'RELAY_LOG_FILE',
	'RELAY_LOG_POS',
	'RELAY_THREAD',
	'RELEASE',
	'RELOAD',
	'RENAME',
	'REPAIR',
	'REPEAT',
	'REPEATABLE',
	'REPLACE',
	'REPLICATION',
	'REQUIRE',
	'RESET',
	'RESTORE',
	'RESTRICT',
	'RESUME',
	'RETURN',
	'RETURNS',
	'REVOKE',
	'RIGHT',
	'RLIKE',
	'ROLLBACK',
	'ROLLUP',
	'ROUTINE',
	'ROW',
	'ROWS',
	'ROW_FORMAT',
	'RTREE',
	'SAVEPOINT',
	'SCHEMA',
	'SCHEMAS',
	'SECOND',
	'SECOND_MICROSECOND',
	'SECURITY',
	'SELECT',
	'SENSITIVE',
	'SEPARATOR',
	'SERIAL',
	'SERIALIZABLE',
	'SESSION',
	'SET',
	'SHARE',
	'SHOW',
	'SHUTDOWN',
	'SIGNED',
	'SIMPLE',
	'SLAVE',
	'SMALLINT',
	'SNAPSHOT',
	'SOME',
	'SONAME',
	'SOUNDS',
	'SPATIAL',
	'SPECIFIC',
	'SQL',
	'SQLEXCEPTION',
	'SQLSTATE',
	'SQLWARNING',
	'SQL_BIG_RESULT',
	'SQL_BUFFER_RESULT',
	'SQL_CACHE',
	'SQL_CALC_FOUND_ROWS',
	'SQL_NO_CACHE',
	'SQL_SMALL_RESULT',
	'SQL_THREAD',
	'SQL_TSI_DAY',
	'SQL_TSI_FRAC_SECOND',
	'SQL_TSI_HOUR',
	'SQL_TSI_MINUTE',
	'SQL_TSI_MONTH',
	'SQL_TSI_QUARTER',
	'SQL_TSI_SECOND',
	'SQL_TSI_WEEK',
	'SQL_TSI_YEAR',
	'SSL',
	'START',
	'STARTING',
	'STATUS',
	'STOP',
	'STORAGE',
	'STRAIGHT_JOIN',
	'STRING',
	'STRIPED',
	'SUBJECT',
	'SUPER',
	'SUSPEND',
	'TABLE',
	'TABLES',
	'TABLESPACE',
	'TEMPORARY',
	'TEMPTABLE',
	'TERMINATED',
	'TEXT',
	'THEN',
	'TIME',
	'TIMESTAMP',
	'TIMESTAMPADD',
	'TIMESTAMPDIFF',
	'TINYBLOB',
	'TINYINT',
	'TINYTEXT',
	'TO',
	'TRAILING',
	'TRANSACTION',
	'TRIGGER',
	'TRIGGERS',
	'TRUE',
	'TRUNCATE',
	'TYPE',
	'TYPES',
	'UNCOMMITTED',
	'UNDEFINED',
	'UNDO',
	'UNICODE',
	'UNION',
	'UNIQUE',
	'UNKNOWN',
	'UNLOCK',
	'UNSIGNED',
	'UNTIL',
	'UPDATE',
	'USAGE',
	'USE',
	'USER',
	'USER_RESOURCES',
	'USE_FRM',
	'USING',
	'UTC_DATE',
	'UTC_TIME',
	'UTC_TIMESTAMP',
	'VALUE',
	'VALUES',
	'VARBINARY',
	'VARCHAR',
	'VARCHARACTER',
	'VARIABLES',
	'VARYING',
	'VIEW',
	'WARNINGS',
	'WEEK',
	'WHEN',
	'WHERE',
	'WHILE',
	'WITH',
	'WORK',
	'WRITE',
	'X509',
	'XA',
	'XOR',
	'YEAR',
	'YEAR_MONTH',
	'ZEROFILL'
);
/**
 * count($PMA_SQPdata_forbidden_word);
 *
 * @global integer MySQL forbidden words count
 */
$PMA_SQPdata_forbidden_word_cnt = 483;

/**
 * the MySQL column/data types
 *
 * @see http://dev.mysql.com/doc/refman/5.1/en/data-types.html
 * @see http://dev.mysql.com/doc/refman/5.1/en/mysql-spatial-datatypes.html
 *
 * @global array MySQL column types
 */
$PMA_SQPdata_column_type = array (
	'BIGINT',
	'BINARY',
	'BIT',
	'BLOB',
	'BOOL',
	'BOOLEAN',			  // numeric-type-overview.html
	'CHAR',
	'CHARACTER',
	'DATE',
	'DATETIME',
	'DEC',
	'DECIMAL',
	'DOUBLE',
	'ENUM',
	'FLOAT',
	'FLOAT4',
	'FLOAT8',
	'GEOMETRY',			 // spatial
	'GEOMETRYCOLLECTION',   // spatial
	'INT',
	'INT1',
	'INT2',
	'INT3',
	'INT4',
	'INT8',
	'INTEGER',
	'LINESTRING',		   // spatial
	'LONG',
	'LONGBLOB',
	'LONGTEXT',
	'MEDIUMBLOB',
	'MEDIUMINT',
	'MEDIUMTEXT',
	'MIDDLEINT',
	'MULTILINESTRING',	  // spatial
	'MULTIPOINT',		   // spatial
	'MULTIPOLYGON',		 // spatial
	'NCHAR',
	'NUMERIC',
	'POINT',				// spatial
	'POLYGON',			  // spatial
	'REAL',
	'SERIAL',			   // alsias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
	'SET',
	'SMALLINT',
	'TEXT',
	'TIME',
	'TIMESTAMP',
	'TINYBLOB',
	'TINYINT',
	'TINYTEXT',
	'VARBINARY',
	'VARCHAR',
	'YEAR'
);
/**
 * $PMA_SQPdata_column_type_cnt = count($PMA_SQPdata_column_type);
 *
 * @global integer MySQL column types count
 */
$PMA_SQPdata_column_type_cnt = 54;

/*
 * check counts
foreach ($GLOBALS as $n => $a) {
	echo is_array($a) ? $n . ': ' . count($a) . '<br />' : '';
}
 */
?>
